package jpa.entitys.synchro.staging;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the MM_SUPPDEBITNOTESINB database table.
 * 
 */
@Entity
@Table(name="MM_SUPPDEBITNOTESINB")
@NamedQueries({
    @NamedQuery(name = "MmSuppdebitnotesinb.findAll", query = " SELECT c FROM MmSuppdebitnotesinb c order by c.company,c.project,c.buildingPhase,c.grnSeqNo,c.itemCode,c.seqNo asc"),
    @NamedQuery(name = "MmSuppdebitnotesinb.findById", query = " SELECT c FROM MmSuppdebitnotesinb c WHERE c.promisStagingId = :Id "),
    @NamedQuery(name = "MmSuppdebitnotesinb.findByInstanceNo", query = " SELECT c FROM MmSuppdebitnotesinb c WHERE c.instanceNo = :instanceNo And c.issync = 'N' order by c.grnSeqNo,c.itemCode,c.seqNo asc"),
    @NamedQuery(name = "MmSuppdebitnotesinb.findByInstanceNoWithoutIsSync", query = " SELECT c FROM MmSuppdebitnotesinb c WHERE c.instanceNo = :instanceNo order by c.grnSeqNo,c.itemCode,c.seqNo asc"),
    @NamedQuery(name = "MmSuppdebitnotesinb.findAllIsSync", query = " SELECT c FROM MmSuppdebitnotesinb c WHERE c.issync = :issync order by c.instanceNo,c.grnSeqNo,c.itemCode,c.seqNo asc")
    })
public class MmSuppdebitnotesinb extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID")
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTION_HANDLER")
	private String actionHandler;

	@Column(name="BUILDING_PHASE")
	private String buildingPhase;

	private String company;

	@Column(name="COST_BF_VAT")
	private String costBfVat;

	@Column(name="COST_OF_GOODS_LOCAL")
	private String costOfGoodsLocal;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_ON")
	private String createdOn;

	@Column(name="DBNOTE_AMOUNT")
	private String dbnoteAmount;

	@Column(name="DEBIT_AMOUNT")
	private String debitAmount;

	@Column(name="DOC_DATE")
	private String docDate;

	@Column(name="EXT_PO_NO")
	private String extPoNo;

	@Column(name="EXT_PO_SEQ")
	private String extPoSeq;

	@Column(name="EXT_REF_KEY")
	private String extRefKey;

	@Column(name="EXT_REF_NO")
	private String extRefNo;

	@Column(name="GRN_SEQ_NO")
	private String grnSeqNo;

	@Column(name="INSTANCE_NO")
	private String instanceNo;

	@Column(name="INTERFACE_NO")
	private String interfaceNo;

	private String isactive;

	private String issync;

	@Column(name="ITEM_CODE")
	private String itemCode;

	@Column(name="ITEM_RATE")
	private String itemRate;

	@Column(name="LIV_DOC")
	private String livDoc;

	@Column(name="MSG_ACT_RESULT")
	private String msgActResult;

	@Column(name="MSG_ALT_DESC")
	private String msgAltDesc;

	@Column(name="MSG_CODE")
	private String msgCode;

	@Column(name="MSG_DESC")
	private String msgDesc;

	@Column(name="NET_AMOUNT")
	private String netAmount;

	@Column(name="NET_DBNOTE_AMOUNT")
	private String netDbnoteAmount;

	@Column(name="PMS_57_DEBIT_NOTE_NO")
	private long pms57DebitNoteNo;

	@Column(name="PMS_57_DEBIT_NOTE_SERIES")
	private String pms57DebitNoteSeries;

	@Column(name="PMS_57_DEBIT_NOTE_TYPE")
	private String pms57DebitNoteType;

	@Column(name="PMS_57_DOCUMENT_NO")
	private String pms57DocumentNo;

	@Column(name="PMS_AP_DOCUMENT_NO")
	private String pmsApDocumentNo;

	@Column(name="PMS_AP_SEQ_NO")
	private long pmsApSeqNo;

	@Column(name="PMS_AP_VOUCHER_NUMBER")
	private long pmsApVoucherNumber;

	@Column(name="PMS_AP_VOUCHER_SERIES")
	private String pmsApVoucherSeries;

	@Column(name="PMS_AP_VOUCHER_TYPE")
	private String pmsApVoucherType;

	private String project;

	@Column(name="PROMIS_STAGING_INT_ID")
	private BigDecimal promisStagingIntId;

	private String quantity;

	@Column(name="REF_NO")
	private String refNo;

	@Column(name="REF_SYNC_PK_ID")
	private String refSyncPkId;

	@Column(name="SAP_COMPANY_CODE")
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE")
	private String sapPlantCode;

	@Column(name="SEQ_NO")
	private BigDecimal seqNo;

	private String status;

	@Column(name="SUPPLIER_AMOUNT_LOCAL")
	private String supplierAmountLocal;

	@Column(name="SUPPLIER_CODE")
	private String supplierCode;

	@Column(name="SUPPLIER_REFERENCE")
	private String supplierReference;

	@Column(name="SUPPLIER_REFERENCE_DATE")
	private String supplierReferenceDate;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

	@Temporal(TemporalType.DATE)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

	@Temporal(TemporalType.DATE)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TAX_TYPE")
	private String taxType;

	@Column(name="TOTAL_COST")
	private String totalCost;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

	@Column(name="UPDATED_BY")
	private String updatedBy;

	@Column(name="UPDATED_ON")
	private String updatedOn;

	@Column(name="VAT_AMOUNT_D")
	private String vatAmountD;

	@Column(name="VAT_AMOUNT_H")
	private String vatAmountH;

	@Column(name="VOUCHER_NUMBER")
	private BigDecimal voucherNumber;

	@Column(name="VOUCHER_SERIES")
	private String voucherSeries;

	@Column(name="VOUCHER_TYPE")
	private String voucherType;

	@Column(name="ZONE_CODE")
	private String zoneCode;

	public MmSuppdebitnotesinb() {
	}

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getBuildingPhase() {
		return this.buildingPhase;
	}

	public void setBuildingPhase(String buildingPhase) {
		this.buildingPhase = buildingPhase;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getCostBfVat() {
		return this.costBfVat;
	}

	public void setCostBfVat(String costBfVat) {
		this.costBfVat = costBfVat;
	}

	public String getCostOfGoodsLocal() {
		return this.costOfGoodsLocal;
	}

	public void setCostOfGoodsLocal(String costOfGoodsLocal) {
		this.costOfGoodsLocal = costOfGoodsLocal;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getDbnoteAmount() {
		return this.dbnoteAmount;
	}

	public void setDbnoteAmount(String dbnoteAmount) {
		this.dbnoteAmount = dbnoteAmount;
	}

	public String getDebitAmount() {
		return this.debitAmount;
	}

	public void setDebitAmount(String debitAmount) {
		this.debitAmount = debitAmount;
	}

	public String getDocDate() {
		return this.docDate;
	}

	public void setDocDate(String docDate) {
		this.docDate = docDate;
	}

	public String getExtPoNo() {
		return this.extPoNo;
	}

	public void setExtPoNo(String extPoNo) {
		this.extPoNo = extPoNo;
	}

	public String getExtPoSeq() {
		return this.extPoSeq;
	}

	public void setExtPoSeq(String extPoSeq) {
		this.extPoSeq = extPoSeq;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getGrnSeqNo() {
		return this.grnSeqNo;
	}

	public void setGrnSeqNo(String grnSeqNo) {
		this.grnSeqNo = grnSeqNo;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getInterfaceNo() {
		return this.interfaceNo;
	}

	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getItemCode() {
		return this.itemCode;
	}

	public void setItemCode(String itemCode) {
		this.itemCode = itemCode;
	}

	public String getItemRate() {
		return this.itemRate;
	}

	public void setItemRate(String itemRate) {
		this.itemRate = itemRate;
	}

	public String getLivDoc() {
		return this.livDoc;
	}

	public void setLivDoc(String livDoc) {
		this.livDoc = livDoc;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getNetAmount() {
		return this.netAmount;
	}

	public void setNetAmount(String netAmount) {
		this.netAmount = netAmount;
	}

	public String getNetDbnoteAmount() {
		return this.netDbnoteAmount;
	}

	public void setNetDbnoteAmount(String netDbnoteAmount) {
		this.netDbnoteAmount = netDbnoteAmount;
	}

	public long getPms57DebitNoteNo() {
		return this.pms57DebitNoteNo;
	}

	public void setPms57DebitNoteNo(long pms57DebitNoteNo) {
		this.pms57DebitNoteNo = pms57DebitNoteNo;
	}

	public String getPms57DebitNoteSeries() {
		return this.pms57DebitNoteSeries;
	}

	public void setPms57DebitNoteSeries(String pms57DebitNoteSeries) {
		this.pms57DebitNoteSeries = pms57DebitNoteSeries;
	}

	public String getPms57DebitNoteType() {
		return this.pms57DebitNoteType;
	}

	public void setPms57DebitNoteType(String pms57DebitNoteType) {
		this.pms57DebitNoteType = pms57DebitNoteType;
	}

	public String getPms57DocumentNo() {
		return this.pms57DocumentNo;
	}

	public void setPms57DocumentNo(String pms57DocumentNo) {
		this.pms57DocumentNo = pms57DocumentNo;
	}

	public String getPmsApDocumentNo() {
		return this.pmsApDocumentNo;
	}

	public void setPmsApDocumentNo(String pmsApDocumentNo) {
		this.pmsApDocumentNo = pmsApDocumentNo;
	}

	public long getPmsApSeqNo() {
		return this.pmsApSeqNo;
	}

	public void setPmsApSeqNo(long pmsApSeqNo) {
		this.pmsApSeqNo = pmsApSeqNo;
	}

	public long getPmsApVoucherNumber() {
		return this.pmsApVoucherNumber;
	}

	public void setPmsApVoucherNumber(long pmsApVoucherNumber) {
		this.pmsApVoucherNumber = pmsApVoucherNumber;
	}

	public String getPmsApVoucherSeries() {
		return this.pmsApVoucherSeries;
	}

	public void setPmsApVoucherSeries(String pmsApVoucherSeries) {
		this.pmsApVoucherSeries = pmsApVoucherSeries;
	}

	public String getPmsApVoucherType() {
		return this.pmsApVoucherType;
	}

	public void setPmsApVoucherType(String pmsApVoucherType) {
		this.pmsApVoucherType = pmsApVoucherType;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public BigDecimal getPromisStagingIntId() {
		return this.promisStagingIntId;
	}

	public void setPromisStagingIntId(BigDecimal promisStagingIntId) {
		this.promisStagingIntId = promisStagingIntId;
	}

	public String getQuantity() {
		return this.quantity;
	}

	public void setQuantity(String quantity) {
		this.quantity = quantity;
	}

	public String getRefNo() {
		return this.refNo;
	}

	public void setRefNo(String refNo) {
		this.refNo = refNo;
	}

	public String getRefSyncPkId() {
		return this.refSyncPkId;
	}

	public void setRefSyncPkId(String refSyncPkId) {
		this.refSyncPkId = refSyncPkId;
	}

	public String getSapCompanyCode() {
		return this.sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public BigDecimal getSeqNo() {
		return this.seqNo;
	}

	public void setSeqNo(BigDecimal seqNo) {
		this.seqNo = seqNo;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSupplierAmountLocal() {
		return this.supplierAmountLocal;
	}

	public void setSupplierAmountLocal(String supplierAmountLocal) {
		this.supplierAmountLocal = supplierAmountLocal;
	}

	public String getSupplierCode() {
		return this.supplierCode;
	}

	public void setSupplierCode(String supplierCode) {
		this.supplierCode = supplierCode;
	}

	public String getSupplierReference() {
		return this.supplierReference;
	}

	public void setSupplierReference(String supplierReference) {
		this.supplierReference = supplierReference;
	}

	public String getSupplierReferenceDate() {
		return this.supplierReferenceDate;
	}

	public void setSupplierReferenceDate(String supplierReferenceDate) {
		this.supplierReferenceDate = supplierReferenceDate;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTaxType() {
		return this.taxType;
	}

	public void setTaxType(String taxType) {
		this.taxType = taxType;
	}

	public String getTotalCost() {
		return this.totalCost;
	}

	public void setTotalCost(String totalCost) {
		this.totalCost = totalCost;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

	public String getVatAmountD() {
		return this.vatAmountD;
	}

	public void setVatAmountD(String vatAmountD) {
		this.vatAmountD = vatAmountD;
	}

	public String getVatAmountH() {
		return this.vatAmountH;
	}

	public void setVatAmountH(String vatAmountH) {
		this.vatAmountH = vatAmountH;
	}

	public BigDecimal getVoucherNumber() {
		return this.voucherNumber;
	}

	public void setVoucherNumber(BigDecimal voucherNumber) {
		this.voucherNumber = voucherNumber;
	}

	public String getVoucherSeries() {
		return this.voucherSeries;
	}

	public void setVoucherSeries(String voucherSeries) {
		this.voucherSeries = voucherSeries;
	}

	public String getVoucherType() {
		return this.voucherType;
	}

	public void setVoucherType(String voucherType) {
		this.voucherType = voucherType;
	}

	public String getZoneCode() {
		return this.zoneCode;
	}

	public void setZoneCode(String zoneCode) {
		this.zoneCode = zoneCode;
	}

}